Forum: Server Utilities «»
Posted on: Wed, 01 December 2004 20:44 «»
By:Shankar Lakkaraju Import-Export issue - Version difference
…Experts,
I have a .dmp file created using Oracle 9.2.0.3 export utility.
Can I import that .dmp to an Oracle 8.17 DB using Oracle 8i import utility. If so, are there any settings that I need to do ?
I tried using Oracle 8i import utility .... got …
2
Forum: SQL & PL/SQL «»
Posted on: Thu, 25 November 2004 20:28 «»
By:Shankar Lakkaraju How to write the update command ?
…Experts,
I have two tables - table1 & table2
Have one date field in table1 - table1.date1
In table2, I have an integravalue - table2.intVal(units:days)
I need to update table1 with ...
table1.date1 = table1.date1 - table2.intVal
I have a valid join…
3
Forum: SQL & PL/SQL «»
Posted on: Fri, 19 November 2004 02:11 «»
By:Shankar Lakkaraju Re: complex query
…the following situation:
NR STATUS
--------------
1 OK
2 OK
3 OK
4 OK
5 OK
6 OK
7 OK
8 NOT OK
9 OK
10 OK
11 NOT OK
12 OK
13 OK
There are multiple occurences of "NOT OK".
So, if the desired output would be NR=3 TO 11.
Then, the following …
Blog
Search
Help
Members
Register
Login
Home